CREATE TABLE [dbo].[UD_Table]
(
[TABLE_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Table_TABLE_NAME] DEFAULT (''),
[DESCRIPTION] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Table_DESCRIPTION] DEFAULT (''),
[APPLICATION] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Table_APPLICATION] DEFAULT (''),
[EXTERNAL_FLAG] [bit] NOT NULL CONSTRAINT [DF_UD_Table_EXTERNAL_FLAG] DEFAULT ((0)),
[LINK_VIA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Table_LINK_VIA] DEFAULT (''),
[ALLOW_MULTIPLE_INSTANCES] [bit] NOT NULL CONSTRAINT [DF_UD_Table_ALLOW_MULTIPLE_INSTANCES] DEFAULT ((0)),
[REQUIRED] [bit] NOT NULL CONSTRAINT [DF_UD_Table_REQUIRED] DEFAULT ((0)),
[EDIT_TYPES] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Table_EDIT_TYPES] DEFAULT (''),
[NAME_ALL_TABLE] [bit] NOT NULL CONSTRAINT [DF_UD_Table_NAME_ALL_TABLE] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UD_Table] ADD CONSTRAINT [PK_UD_Table] PRIMARY KEY CLUSTERED ([TABLE_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[UD_Table] TO [IMIS]
GRANT SELECT ON  [dbo].[UD_Table] TO [IMIS]
GRANT INSERT ON  [dbo].[UD_Table] TO [IMIS]
GRANT DELETE ON  [dbo].[UD_Table] TO [IMIS]
GRANT UPDATE ON  [dbo].[UD_Table] TO [IMIS]
GO